Tabela DgDrugDBType

Definicja tabeli DgDrugDBType

Name

DgDrugDBType

Code

DgDrugDBType

Comment

informacje o bazie leków/interakcji


Lista kolumn tabeli DgDrugDBType

Name

Code

DrugDBTypeID

DrugDBTypeID

Active

Active

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

Version

Version

VersionDT

VersionDT


Kolumna DrugDBTypeID tabeli DgDrugDBType

Definicja kolumny DrugDBTypeID tabeli DgDrugDBType

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli DgDrugDBType

Definicja kolumny Active tabeli DgDrugDBType

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Kolumna Code tabeli DgDrugDBType

Definicja kolumny Code tabeli DgDrugDBType

Name

Code

Code

Code

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli DgDrugDBType

Definicja kolumny ShortName tabeli DgDrugDBType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FullName tabeli DgDrugDBType

Definicja kolumny FullName tabeli DgDrugDBType

Name

FullName

Code

FullName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Description tabeli DgDrugDBType

Definicja kolumny Description tabeli DgDrugDBType

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Version tabeli DgDrugDBType

Definicja kolumny Version tabeli DgDrugDBType

Name

Version

Code

Version

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna VersionDT tabeli DgDrugDBType

Definicja kolumny VersionDT tabeli DgDrugDBType

Name

VersionDT

Code

VersionDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli DgDrugDBType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DgDrugDBType

Definicja klucza Identifier_1 tabeli DgDrugDBType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment